Ryan Sides Community Champion

Overview

Overview

Email	rsides27@gmail.com
Roles	Member
Badges	25

About Me

About Me

Area of Expertise	Business Process Improvement; using Smartsheet to it's full capabilities. Control Center, Data Shuttle/Mesh, Dynamic View, Resource Management, and others.
About Me	I help organizations of various sizes get the most from their Smartsheet licenses.
How I Use Smartsheet	As a consultant helping others. Feel free to drop me a line. I'm always glad to help!
Linkedin	https://www.linkedin.com/in/business-operations-consultant-coach/

Analytics

516

Posts

540

Visits

1.6k

Points

May 31, 2022

Join Date

Feb 27, 2025

Last Active

Reactions

• Insightful 11

  11
• Vote Up 29

  29
• Awesome 56

  56
• Spam 2

  2

• Activity
• Discussions9
• Comments507

• Re: Aggregate Red, Yellow, Green Status to One Overall Grade

  Ryan Sides

  10/27/22
  @Marvin Francis Hi Marvin, you were very close! Since your red requirement overrides all others, you can put it first. Then check for any greens. If not either of those, it's yellow... =IF(OR([Class1…
  1 ·

• Re: INDEX, MATCH, IF Formula

  Ryan Sides

  10/26/22
  @Maximus Great point! One caution with VLOOKUP is that if the column sequence changes (someone adds an additional column in the middle), the formula breaks. I was a VLOOKUP fan forever then, my colum…
  1 ·

• Re: Formula Help with multiple conditions

  Ryan Sides

  10/26/22
  @otavilog Sweet! Enjoy. - Ryan
  1 ·

• Re: Date Comparison

  Ryan Sides

  10/25/22
  Hi @dsmartsheetuser Hi Deepthi, try this one... =if([Date1]@row < today(), [Date2]@row) Did that help?
  1 ·

Previous